To Create a Feature of Type Line

Create the table with one geometry column and one ID.

CREATE TABLE LINE
(ID NUMBER PRIMARY KEY,
Geometry MDSYS.SDO_GEOMETRY);

Insert the table metadata in the Oracle Spatial metadata.

INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID) 
VALUES (‘LINE', 'Geometry',
MDSYS.SDO_DIM_ARRAY 
MDSYS.SDO_DIM_ELEMENT('X', 714099.913898663, 715312.343907550, 0.000000050),
MDSYS.SDO_DIM_ELEMENT('Y', 4908438.586694972, 4910715.465519385, 0.000000050)), 
88247;

Create the spatial index of type multicurve to use model multi-geometry objects.

CREATE INDEX LINE_IDX ON Line(Geometry) 
INDEXTYPE IS MDSYS.SPATIAL_INDEX_V2 PARAMETERS ('layer_gtype=multicurve');